Encrypt a SQL session with PowerBI Desktop
I want to connect to a local SQL Server database, using Power BI Desktop. On the SQL Server instance encryption has been enforced. When I make the connection Power BI Desktop keeps telling that it cannot make a connection because encryption is not…
I am facing Issues for data replication of specific tables (Bi-Directional) in SQL databases at two different regions hosted on Azure Cloud.
Hi, I have SQL Databases in Europe Region & USA Region hosted on Microsoft Azure cloud. I want to sync specific tables of both databases. I have researched about database replication approach (Transactional Replication, Snapshot Replication,…
How can we access SQL Server hosted on on-premises from Function app
I am trying to access SQL Server hosted on Azure VM from Function app using python. But I am getting this error: Result: Failure Exception: OperationalError: (pyodbc.OperationalError) ('HYT00', '[HYT00] [Microsoft][ODBC Driver 18 for SQL Server]Login…
-2061893606 error
ERRORLOG.txt I can't download sql server
Unable to install SQL Server (setup.exe). Exit code (Decimal): -2061893606Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
I have been trying to run kestrel in Visual Studio, and then I got this message: System.AggregateException: 'One or more errors occurred. (A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server…
SQL Connectivity Issue From Cloud app to on-prem server
hi, I have deployed a .net core MVC app in azure app service as a webapp. I have to connect to a on-prem sql server to retrieve data. I have setup Azure relay/hybrid connection for the same. Also I have installed hybrid connection manager in on-prem…
Azure Managed disk performance analysis for SQL Server DB Backup
We are currently trying to optimize cost in our Azure environment and are reviewing dedicated backup disks on servers. We have a few servers running single Premium SSD P50 - 4TB as backup disks, but the actual backup files on these drives are often less…
I have a problem with the SQL server. The connection is disconnected. Sometimes I looked in the events. The code prints event 17886.
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> <System> <Provider Name="MSSQLSERVER" /> <EventID Qualifiers="49152">17886</EventID> …
How to restore SQL server 2019 database backup (.bak) to SQL server 2017.
Hi, In one of our legacy project we are using SQL Server 2017 database, and in this we need to restore backup (.bak) taken from SQL Server 2019 database. While database restore (taken from 2019) in SQL server 2017 we are getting incompatibility error. …
Will there be any problems in directly replacing the version of Log4j.jar from 1.17 to 2.X in SQL Server 2019?
Hi Team, Background: We now have installed Microsoft SQL Server 2019 Express locally. After installation, we found that it automatically uses the Log4j 1.2.17 version jar package. (As shown in the picture.) Since the jar package of Log4j version 1.2.17…
SQL backups are getting failed with below error
Error encountered while trying to open backup device. Error: [Microsoft.SqlServer.Management.Common.ExecutionFailureException:Cannot open backup device '8122c6ff-b1c3-4550-a77b-c79a3066c737'. Operating system error 0x80770006(failed to retrieve text for…
How to sql dump generation on sql server 2008 ?
Good morning, I use SQL SERVER 2008 R2 and for a few days now I have had disk C filling up due to the generation of SQLDUMP files in the log directory. Can you give me the procedure to disable the generation of these files please. Thanks in advance.
How to grant a single SSRS User access to multiple folders
Is there any way to grant a SSRS login the same level of access to multiple folders in one shot instead of going through each and any Folder that has "custom" security or in other words not inherited from parent "Home"? In new SSRS…
Unable to connect to my SQL Server/Database. Listed resources on Microsoft do not address this issue.
Error codeSqlFailedToConnect DetailsCannot connect to SQL Database. Please contact SQL server team for further support. Server: 'blazor-wasm-app.database.windows.net', Database: 'BrandedFoodMacrosContent', User: [...BLANK...] Check the linked service…
SQL Select subquery using exists
I am trying to write a query with a subquery. The subquery returns what is in the attached image below. select top(1) with ties matter_uno, PART_CAT_CODE, EFF_DATE, EMPL_UNO from TBM_CLMAT_PART where MATTER_UNO = 11275 and PART_CAT_CODE = 'BILL' order…
Unable to install SQL Server. Exit code (Decimal): -2064908287
Hi, I tried to reinstall SQL server and it shows this error, please tell me how to solve this problem. Thank you. This is all it says in the summary file Overall summary: Final result: Failed: see details below Exit code…
can not start sql server2012.the request failed or ther service did not respond in a timely fashion.
This error will be reported after starting sql server 2012, check the log,Please refer to the following picture to view the log. How to solve it? The description for Event ID 17836 from source MSSQL$MSSQL2012 cannot be found. Either the component that…
SQL2022-SSEI-Expr setup file is not opening
I downloaded the express edition file from here :https://www.microsoft.com/en-us/sql-server/sql-server-downloads When I try to open it , the file dont open . dont know whats wrong with it. Need Help with the installation. TIA
How can I run an automation template
I want to run an automation template for a sql database deployed with ARM. The aim is to trigger a stored procedure
Keep getting this error regardless to the accoun tused
SQL server 2022 / SSRS 2022, getting this error even when using an admin account An error has occurred during report processing. (rsProcessingAborted) Cannot impersonate user for data source 'AutoGen__5C6349F2_4BB6_4a1b_A16E_8D69795D8602_'.…